Hello, Here my configuration: Operating System environnement: Microsoft Windows Server 2003, Enterprise Edition x64 - R2 Version 5.2.3790 ServicePack 2 Nu 3790 Type x64 **** Microsoft Exchange Environnement: Exchange Server 2007 Microsoft Corporation Version : 08.01.0263.000 --> In the Active Directory I have the field "City" filled in. And from the EMC I try to create an Address List based on the city attribut. For example I have users in Spain belonging to Madrid and Barcelona sites. Both have the city field filled in the AD (Madrid or Barcelona). When I try to create the Address List I only have the option based on the "State/province" and "Country/region" Can you tell me whether it would be possible to set up an address list based on the city field?? Thanks

You can script re-populating the City field into an unused Custom Attribute if you have one, and then use that. I don't know of any way to get it to use the City field directly.

Hi, You can create an addresslist using the city attribute like this: new-addresslist -name "TestALCity" -RecipientFilter {(RecipientType -eq 'UserMailbox') -and (City -eq 'Washington')} Put whatever city you want instead of "Washington". like new-addresslist -name "TestALCity" -RecipientFilter {(RecipientType -eq 'UserMailbox') -and (City -eq 'Barcelona' -or City -eq 'Madrid')} Regards, Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com

Sorry, I misread that as being Exchange 2003.

Thanks Laeeq, Put I am a bit confused. I have 100 users in Barcelona and 200 in Madrid. How do I do the difference between those 2? new-addresslist -name "Barcelona" -RecipientFilter {(RecipientType -eq 'UserMailbox') -and (City -eq ' Barcelona ')} I have users who have mailbox and mailuser. Shall I specify somthing instead of -RecipientFilter {(RecipientType -eq 'UserMailbox') ??

Thanks Laeeq, Put I am a bit confused. I have 100 users in Barcelona and 200 in Madrid. How do I do the difference between those 2? new-addresslist -name "Barcelona" -RecipientFilter {(RecipientType -eq 'UserMailbox') -and (City -eq ' Barcelona ')} I have users who have mailbox and mailuser. Shall I specify somthing instead of -RecipientFilter {(RecipientType -eq 'UserMailbox') ?? For adding MailUsers to the address list u will have to add -or RecipientType -eq 'MailUser' like new-addresslist -name "Barcelona" -RecipientFilter {(RecipientType -eq 'UserMailbox' -or RecipientType -eq 'MailUser' ) -and (City -eq ' Barcelona ')} I have 100 users in Barcelona and 200 in Madrid. How do I do the difference between those 2? You can create separate address lists for both type of users, it all depends on your need. new-addresslist -name "Madrid" -RecipientFilter {(RecipientType -eq 'UserMailbox' -or RecipientType -eq 'MailUser' ) -and (City -eq ' Madrid')} Note: RecipientType can be UserMailbox MailUser MailContact MailUniversalDistributionGroup MailUniversalSecurityGroup MailNonUniversalGroup DynamicDistributionGroup PublicFolder Regards, Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com

Very useful :-) It worked. I had to do the below shell command to see the result: update-AddressList -Identity "\Madrid" Am I correct? Or I should have done thaht one first: set-AddressList -Instance "\Madrid"

Very useful :-) It worked. I had to do the below shell command to see the result: update-AddressList -Identity "\Madrid" Am I correct? Or I should have done thaht one first: set-AddressList -Instance "\Madrid" Can u tell what do u mean by "to see the result". Update-AddressList updates the address lists, so that AddressList contains all the latest recipient too in your exchange organization. set-addressList is used to modify the properties of the Address List, like if we want to modify the RecipientFilter of the AL then we will use set-addressList. Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com

After running the shell command, If I connect on the OWA I don't see the users. I did update them from the console but I thought I could have done it using shell command line to avoid doing it on the console. I also noticed that I have user deactivated belonging to the address lists all of the deactivated users are located under the same OrganizationalUnit "COMPANY.intra/Company/Old/Users". I was wondering if I could remove the "City" attribute. I have tried to check the desctivated user but it did not work: [PS] C:\>Get-MailBox -ResultSize Unlimited | where {$_.OrganizationalUnit -like "COMPANY.intra/Company/Old/Users" >> Do you know how I could change the city "madrid" to "" in that specific OU ?? then I no longer have the deactivate user in the address lists. Thanks again for your help. It worked well!

After running the shell command, If I connect on the OWA I don't see the users. I did update them from the console but I thought I could have done it using shell command line to avoid doing it on the console. I also noticed that I have user deactivated belonging to the address lists all of the deactivated users are located under the same OrganizationalUnit "COMPANY.intra/Company/Old/Users". I was wondering if I could remove the "City" attribute. I have tried to check the desctivated user but it did not work: [PS] C:\>Get-MailBox -ResultSize Unlimited | where {$_.OrganizationalUnit -like "COMPANY.intra/Company/Old/Users" >> Do you know how I could change the city "madrid" to "" in that specific OU ?? then I no longer have the deactivate user in the address lists. Thanks again for your help. It worked well! Plz try it: Get-MailBox -ResultSize Unlimited -OrganizationalUnit -"COMPANY.intra/Company/Old/Users" |set-user -city "" and then update-addresslist "Madrid" Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com